﻿GO

ALTER PROCEDURE [dbo].[bhp_NemoGroupSystemNamesGet]
AS
BEGIN
	
	
	SELECT
		id as GroupId,
		name as SystemName
	FROM
		n_Tree
	WHERE
		(del IS NULL OR del = 0)
		AND typ IN ('T', 'V', 'TE')

END